<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<link href="css/page.css" type="text/css" rel="stysheet">
<?php

require_once '../config/config.php';

$connection = mysql_connect(DB_HOST . ":" . DB_PORT, DB_USER, DB_PASS) or die(mysql_error());
mysql_select_db(DB_NAME, $connection);


$query = "select * from pages LIMIT 0, 20";


$data = mysql_query($query, $connection);

echo "<table border='5'>
    <tr>
        <th>PID</th>
        <th>ID</th>
        <th>Name</th>
        <th>Username</th>
        <th>Phone</th>
        <th>Likes</th>
        <th>Talking_about_count</th>
        <th>Category</th>
    </tr>";
while ($row = mysql_fetch_assoc($data)) {
    echo "<tr>";
    echo "<td>".$row['pid']."</td>";
    echo "<td>".$row['id']."</td>";
    echo "<td>".$row['name']."</td>";
    echo "<td>".$row['username']."</td>";
    echo "<td>".$row['phone']."</td>";
    echo "<td>".$row['likes']."</td>";
    echo "<td>".$row['talking_about_count']."</td>";
    echo "<td>".$row['category']."</td>";
}
?>
